﻿USE [ESM]
GO

INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '0_0_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '0_0_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '0_0_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '0_0_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '0_0_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '0_0_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '0_1_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '0_1_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '0_1_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '0_1_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '0_1_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '0_1_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '0_2_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '0_2_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '0_2_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '0_2_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '0_2_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '0_2_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '1_0_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '1_0_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '1_0_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '1_0_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '1_0_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '1_0_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '1_1_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '1_1_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '1_1_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '1_1_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '1_1_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '1_1_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '1_2_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '1_2_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '1_2_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '1_2_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '1_2_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '1_2_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '2_0_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '2_0_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '2_0_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '2_0_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '2_0_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '2_0_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '2_1_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '2_1_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '2_1_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '2_1_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '2_1_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '2_1_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '2_2_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '2_2_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '2_2_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '2_2_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '2_2_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '2_2_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '3_0_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '3_0_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '3_0_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '3_0_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '3_0_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '3_0_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '3_1_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '3_1_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '3_1_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '3_1_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '3_1_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '3_1_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '3_2_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '3_2_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '3_2_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '3_2_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '3_2_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '3_2_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '4_0_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '4_0_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '4_0_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '4_0_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '4_0_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '4_0_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '4_1_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '4_1_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '4_1_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '4_1_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '4_1_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '4_1_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '4_2_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '4_2_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '4_2_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '4_2_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '4_2_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '4_2_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '5_0_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '5_0_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '5_0_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '5_0_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '5_0_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '5_0_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '5_1_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '5_1_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '5_1_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '5_1_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '5_1_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '5_1_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '5_2_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '5_2_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '5_2_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '5_2_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '5_2_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '5_2_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '6_0_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '6_0_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '6_0_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '6_0_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '6_0_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '6_0_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '6_1_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '6_1_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '6_1_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '6_1_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '6_1_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '6_1_5')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '6_2_0')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '6_2_1')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '6_2_2')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '6_2_3')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '6_2_4')
INSERT INTO [dbo].[Period] ([name],[startTime],[endTime],[code]) VALUES ('', '28/03/2010', '28/03/2010', '6_2_5')

SET IDENTITY_INSERT [dbo].[Category] ON
INSERT INTO [dbo].[Category]  ([id], [name])  VALUES (1, 'Account')
INSERT INTO [dbo].[Category]  ([id], [name])  VALUES (2, 'Student Type')
SET IDENTITY_INSERT [dbo].[Category] OFF

SET IDENTITY_INSERT [dbo].[Enums] ON
INSERT INTO [dbo].[Enums]  ([id], [categoryId], [value])  VALUES (1,1, 'Super Admin')
INSERT INTO [dbo].[Enums]  ([id], [categoryId], [value])  VALUES (2,1, 'Admin')
INSERT INTO [dbo].[Enums]  ([id], [categoryId], [value])  VALUES (3,1, 'Teacher')
INSERT INTO [dbo].[Enums]  ([id], [categoryId], [value])  VALUES (4,1, 'Employee')
INSERT INTO [dbo].[Enums]  ([id], [categoryId], [value])  VALUES (5,2, 'Học Sinh')
INSERT INTO [dbo].[Enums]  ([id], [categoryId], [value])  VALUES (6,2, 'Đi Làm')
SET IDENTITY_INSERT [dbo].[Enums] OFF

GO